ETL Developer
Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.
Remedy's mission is to help make prescription drugs more affordable and accessible for payors and patients for optimum health. Our analytics produce an "MRI" of a company's complex Rx spend, uncovering actionable information that saves millions of dollars, while also offering key insight into population health management. All of this can be accomplished without changing the insurer, plan design, PBM, formulary, or clinical programs.
Based in Milwaukee, WI, Remedy has a thriving business with a casual, friendly atmosphere and an entrepreneurial spirit. There are flexible work arrangements with an excellent incentive-compensation program and competitive benefits. Remedy offers an outstanding opportunity to explore, understand and impact the future of healthcare. We're a true team in every sense, and we thrive on ideas, creating new possibilities and solving challenging problems.
We are looking for a full-time ETL Developer to join our growing team. The position will consist of taking raw data using an ETL process into the standardized Remedy Analytics data structure to be easily analyzed by our business users. This role is expected to work directly with internal teammates and external clients/vendors to develop technical solutions that ensure Remedy Analytics data is loaded accurately and timely. The right candidate will be a self-starter who's excited to support our products and data initiatives while ensuring stability, reliability, scalability and performance.
Job Responsibilities
• Develop solutions for optimal extraction, transformation, and loading of data from a wide variety of data sources into targeted databases.
• Support ETL operations and the administration of data and systems securely and in accordance with enterprise data governance standards.
• Follow all department procedures, including source control, release/deployment, and change management procedures.
• Collaborate directly with internal teammates to take business ideas and develop technical requirements that meet the business request.
• Perform quality assurance testing and troubleshooting to ensure all pipeline jobs and technical activities are completed accurately and timely.
• Identify, design, and implement internal process improvements such as automation of manual processes and the optimization of data delivery for greater scalability.
• Support internal IT teammates by helping to implement tools for tracking of data, users & performance of sql queries that enable strategic planning of product enhancements & process improvements.
• Perform root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Create and maintain data-related documentation (e.g. data dictionaries, ERD's, data maps, etc.)
• Comply with and adhere to all regulatory compliance areas, policies and procedures, including HIPAA requirements.
• Work with stakeholders including the Executive, Clinical, and Product teams to assist with data-related technical issues and support their data needs.
• Work with data analytics experts to strive for greater functionality in our data systems and incorporation of governance practices.
• This position will include job duties that require risk designations for access to Electronic Protected Health Information (PHI) in the course of their job responsibilities.
• Other duties as assigned.
Competencies:
• Planning/organizing-the individual prioritizes and plans work activities and uses time efficiently. Makes good and timely decisions that propels our company forward.
• Interpersonal skills-the individual maintains confidentiality, remains open to others' ideas, and exhibits willingness to try new things. Creates an environment where teammates feel connected and energized.
• Written and Oral communication-Communicate a concise message that resonates every time. The individual speaks clearly and persuasively in positive or negative situations and demonstrates group presentation skills.
• Problem solving-Create innovative ways for our customers and our company to be successful. The individual identifies and resolves problems in a timely manner, gathers and analyzes information skillfully and maintains confidentiality.
• Quality control-the individual demonstrates accuracy and thoroughness and monitors own work to ensure quality.
• Self-Driven - the individual has a high level of motivation and is able to work in both a team and independent capacity, making the most of the time available within a workday, and completes items with limited oversight from leadership.
• Adaptability-the individual adapts to changes in the work environment, manages competing demands, and can deal with frequent change, delays or unexpected events.
• Safety and security-the individual observes safety and security procedures and uses equipment and materials properly.
Qualifications:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.
Required Qualifications
• Computer Science Degree of related fields OR direct applicable experience in an enterprise environment
• 2+ years of enterprise experience working directly in relational databases, query authoring (SQL) as well as working familiarity with a variety of databases, technologies, data structures and algorithms.
• 2+ years of enterprise experience using Python
• Proficient experience using Enterprise Data Integration Tools, preferably Azure Data Factory and/or Informatica
• Detailed knowledge of data warehouse concepts and cloud-based infrastructure components.
Preferred Qualifications:
• 2+ years of enterprise experience with ORACLE PL/SQL
• Experience working with Pharmacy and/or Medical claims data and proficient in HIPAA concepts
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $80,000/year in our lowest geographic market up to $100,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience.
We are an Equal Opportunity Employer. We take pride in the diversity of our team and seek diversity in our applicants.
